/*
MySQL Backup
Database: hope_music
Backup Time: 2022-12-27 14:12:34
*/

SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `hope_music`.`user`;
CREATE TABLE `user` (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `userName` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`),
  UNIQUE KEY `userName_UNIQUE` (`userName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
BEGIN;
LOCK TABLES `hope_music`.`user` WRITE;
DELETE FROM `hope_music`.`user`;
INSERT INTO `hope_music`.`user` (`id`,`userName`,`password`) VALUES ('0', 'github', '123456'),('1', 'admin', '123456'),('2', 'class', '123456'),('4', 'mytest', '123456'),('5', 'gitcode', '123456'),('6', 'gitee', '123456');
UNLOCK TABLES;
COMMIT;
